/** */
package co.com.umobile.persistence;

/**
 * Class that define database script.
 * 
 * @author eescudero
 * 
 */
public class DatabaseScript {

	/** Script to create user table. */
	public static final String USER_TABLE_CREATE = "CREATE TABLE IF NOT EXISTS User (userCode text, "
			+ "password text, name text, sessionId text, userType integer, userTypeDescription text, PRIMARY KEY (userCode, userType))";

	/** Script to create notification table. */
	public static final String NOTIFICATION_TABLE_CREATE = "CREATE TABLE IF NOT EXISTS Notification (uuid text PRIMARY KEY, subjectCode text REFERENCES Subject,"
			+ " title text, shortDescription text, largeDescription text, date integer, "
			+ " notificationType integer, notificationTypeDescription text)";

	/** Script to create schedule table. */
	public static final String SUBJECT_TABLE_CREATE = "CREATE TABLE IF NOT EXISTS Subject (subjectCode text PRIMARY KEY, "
			+ " subjectName text,teacherCode text, teacherName text, subjectPeriod text, grade1 real, "
			+ " grade2 real, grade3 real, grade4 real, finalGrade real, definitiveGrade real)";

	/** Script to create place table. */
	public static final String PLACE_TABLE_CREATE = "CREATE TABLE IF NOT EXISTS Place ( "
			+ " placeCode text PRIMARY KEY, placeName text, placeDescription text, room text, block text, placeType integer, placeTypeDescription text, longitude real, latitude real)";

	/** Script to create schedule detail table. */
	public static final String SUBJECT_DETAIL_TABLE_CREATE = "CREATE TABLE IF NOT EXISTS SubjectDetail ( "
			+ " subjectDetailCode text PRIMARY KEY , subjectCode text REFERENCES Subject, subjectDate text, subjectTime text, placeCode text REFERENCES Place)";

//	/** Script to insert a User Type. */
//	public static final String USERTYPE_INSERT_1 = "INSERT INTO UserType VALUES (1,'Estudiante')";
//	public static final String USERTYPE_INSERT_2 = "INSERT INTO UserType VALUES (2,'Profesor')";
//
//	/** Script to insert a User. */
//	public static final String USER_INSERT_1 = "INSERT INTO User VALUES ('1','8161164','Edwin Escudero Restrepo',"
//			+ "'X','FFF6RTTTR',1)";
//	public static final String USER_INSERT_2 = "INSERT INTO User VALUES ('2','98635718','Milton Cesar Ibarra',"
//			+ "'X','FFF6RTTTRWEEW',2)";
//	public static final String USER_INSERT_3 = "INSERT INTO User VALUES ('3','10377222','Sergio Esteban Granada Restrepo',"
//			+ "'X','FFF6RTTTRWEXXXW',1)";
//
//	/** Script to insert a schedule. */
//	public static final String SCHEDULE_INSERT_1 = "INSERT INTO Schedule VALUES ('1', "
//			+ " 'ISI00010', 'INGSWI', 'Ingenieria de software II', 'Orlando Duque', 'S', null, "
//			+ " null, null, null, null, null,  '1' )";
//
//	public static final String SCHEDULE_INSERT_2 = "INSERT INTO Schedule VALUES ('2', "
//			+ " 'ISI00010', 'INGSWI', 'Ingenieria de software II', 'Orlando Duque', 'S', null, "
//			+ " null, null, null, null, null,  '3' )";
//
//	public static final String SCHEDULE_INSERT_3 = "INSERT INTO Schedule VALUES ('3', "
//			+ " 'TPE00010', 'TOPESP', 'Topicos especiales', 'Bernardo Mora', 'S', null, "
//			+ " null, null, null, null, null,  '1' )";
//
//	public static final String SCHEDULE_INSERT_4 = "INSERT INTO Schedule VALUES ('4', "
//			+ " 'TPE00010', 'TOPESP', 'Topicos especiales', 'Bernardo Mora', 'S', null, "
//			+ " null, null, null, null, null,  '2' )";
//
//	public static final String SCHEDULE_INSERT_5 = "INSERT INTO Schedule VALUES ('5', "
//			+ " 'INV00010', 'INGINV', 'Investigaci�n II', 'Jairo Velasquez', 'S', null, "
//			+ " null, null, null, null, null, '1' )";
//
//	public static final String SCHEDULE_INSERT_6 = "INSERT INTO Schedule VALUES ('6', "
//			+ " 'INV00010', 'INGINV', 'Investigaci�n II', 'Jairo Velasquez', 'S', null, "
//			+ " null, null, null, null, null, '2' )";
//
//	/** Script to insert a place Type. */
//	public static final String PLACETYPE_INSERT_1 = "INSERT INTO PlaceType VALUES (1,'Aula')";
//	public static final String PLACETYPE_INSERT_2 = "INSERT INTO PlaceType VALUES (2,'Auditorio')";
//
//	/** Script to insert a place. */
//	public static final String PLACE_INSERT_1 = " INSERT INTO Place VALUES ( "
//			+ " '1', 'Aula 12-101', '101', '12', 1 )";
//
//	public static final String PLACE_INSERT_2 = " INSERT INTO Place VALUES ( "
//			+ " '2', 'Aula 12-102', '102', '12', 1 )";
//
//	public static final String PLACE_INSERT_3 = " INSERT INTO Place VALUES ( "
//			+ " '3', 'Aula 12-103', '103', '12', 1 )";
//
//	public static final String PLACE_INSERT_4 = " INSERT INTO Place VALUES ( "
//			+ " '4', 'Aula 12-104', '104', '12', 1 )";
//
//	public static final String PLACE_INSERT_5 = " INSERT INTO Place VALUES ( "
//			+ " '5', 'Aula 12-105', '105', '12', 1 )";
//
//	public static final String PLACE_INSERT_6 = " INSERT INTO Place VALUES ( " + " '6', 'Auditiorio 1', '1', '12', 2 )";
//
//	public static final String PLACE_INSERT_7 = " INSERT INTO Place VALUES ( " + " '7', 'Auditiorio 2', '2', '12', 2 )";
//
//	/** Script to insert a schedule detail. */
//	public static final String SCHEDULEDETAIL_INSERT_1 = "INSERT INTO ScheduleDetail VALUES ( "
//			+ " 1337096682737,'6-8',null, '1', " + " '1' )";
//
//	public static final String SCHEDULEDETAIL_INSERT_2 = "INSERT INTO ScheduleDetail VALUES ( "
//			+ " 1337096682737,'6-8',null, '2', " + " '1' )";
//
//	public static final String SCHEDULEDETAIL_INSERT_3 = "INSERT INTO ScheduleDetail VALUES ( "
//			+ " 1337096682737,'10-2',null, '3', " + " '2' )";
//
//	public static final String SCHEDULEDETAIL_INSERT_4 = "INSERT INTO ScheduleDetail VALUES ( "
//			+ " 1337096682737,'10-2',null, '4', " + " '2' )";
//
//	public static final String SCHEDULEDETAIL_INSERT_5 = "INSERT INTO ScheduleDetail VALUES ( "
//			+ " 1337096682737,'10-2',null, '5', " + " '6' )";
//
//	public static final String SCHEDULEDETAIL_INSERT_6 = "INSERT INTO ScheduleDetail VALUES ( "
//			+ " 1337096682737,'10-2',null, '6', " + " '6' )";

}
